﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsPermission" targetNamespace="http://tempuri.org/dsPermission.xsd" xmlns:mstns="http://tempuri.org/dsPermission.xsd" xmlns="http://tempuri.org/dsPermission.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblQuyenTableAdapter" GeneratorDataComponentClassName="tblQuyenTableAdapter" Name="tblQuyen" UserDataComponentName="tblQuyenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblQuyen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblQuyen] WHERE (([cUserName] = @Original_cUserName) AND ([iItemID] = @Original_iItemID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblQuyen] ([cUserName], [iItemID], [isAdmin], [cItemTitle], [cItemKey], [iParentID], [ControlInMain], [cTenQuyen], [cMoTa], [bFull], [bTruyCap], [bThem], [bSua], [bXoa], [bIn], [bNhap], [bXuat]) VALUES (@cUserName, @iItemID, @isAdmin, @cItemTitle, @cItemKey, @iParentID, @ControlInMain, @cTenQuyen, @cMoTa, @bFull, @bTruyCap, @bThem, @bSua, @bXoa, @bIn, @bNhap, @bXuat);
SELECT iQuyenID, cUserName, iItemID, isAdmin, cItemTitle, cItemKey, iParentID, ControlInMain, cTenQuyen, cMoTa, bFull, bTruyCap, bThem, bSua, bXoa, bIn, bNhap, bXuat FROM tblQuyen WHERE (cUserName = @cUserName) AND (iItemID = @iItemID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isAdmin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cItemTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cItemKey" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ControlInMain" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ControlInMain" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTenQuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenQuyen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bFull" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bFull" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bTruyCap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bTruyCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bThem" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bThem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bSua" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bSua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bXoa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bIn" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bNhap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bNhap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bXuat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        iQuyenID, cUserName, iItemID, isAdmin, cItemTitle, cItemKey, iParentID, ControlInMain, cTenQuyen, cMoTa, bFull, bTruyCap, bThem, bSua, bXoa, bIn, bNhap, 
                         bXuat
FROM            tblQuyen
WHERE        (ControlInMain &lt;&gt; '') and cUserName=@user</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="user" ColumnName="cUserName" DataSourceName="CrewManagment.dbo.tblQuyen" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@user" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblQuyen] SET [cUserName] = @cUserName, [iItemID] = @iItemID, [isAdmin] = @isAdmin, [cItemTitle] = @cItemTitle, [cItemKey] = @cItemKey, [iParentID] = @iParentID, [ControlInMain] = @ControlInMain, [cTenQuyen] = @cTenQuyen, [cMoTa] = @cMoTa, [bFull] = @bFull, [bTruyCap] = @bTruyCap, [bThem] = @bThem, [bSua] = @bSua, [bXoa] = @bXoa, [bIn] = @bIn, [bNhap] = @bNhap, [bXuat] = @bXuat WHERE (([cUserName] = @Original_cUserName) AND ([iItemID] = @Original_iItemID));
SELECT iQuyenID, cUserName, iItemID, isAdmin, cItemTitle, cItemKey, iParentID, ControlInMain, cTenQuyen, cMoTa, bFull, bTruyCap, bThem, bSua, bXoa, bIn, bNhap, bXuat FROM tblQuyen WHERE (cUserName = @cUserName) AND (iItemID = @iItemID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isAdmin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cItemTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cItemKey" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ControlInMain" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ControlInMain" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTenQuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenQuyen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bFull" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bFull" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bTruyCap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bTruyCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bThem" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bThem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bSua" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bSua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bXoa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bIn" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bNhap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bNhap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bXuat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="iQuyenID" DataSetColumn="iQuyenID" />
              <Mapping SourceColumn="cUserName" DataSetColumn="cUserName" />
              <Mapping SourceColumn="iItemID" DataSetColumn="iItemID" />
              <Mapping SourceColumn="cItemTitle" DataSetColumn="cItemTitle" />
              <Mapping SourceColumn="cItemKey" DataSetColumn="cItemKey" />
              <Mapping SourceColumn="iParentID" DataSetColumn="iParentID" />
              <Mapping SourceColumn="cTenQuyen" DataSetColumn="cTenQuyen" />
              <Mapping SourceColumn="cMoTa" DataSetColumn="cMoTa" />
              <Mapping SourceColumn="bFull" DataSetColumn="bFull" />
              <Mapping SourceColumn="bTruyCap" DataSetColumn="bTruyCap" />
              <Mapping SourceColumn="bThem" DataSetColumn="bThem" />
              <Mapping SourceColumn="bSua" DataSetColumn="bSua" />
              <Mapping SourceColumn="bXoa" DataSetColumn="bXoa" />
              <Mapping SourceColumn="bIn" DataSetColumn="bIn" />
              <Mapping SourceColumn="bNhap" DataSetColumn="bNhap" />
              <Mapping SourceColumn="bXuat" DataSetColumn="bXuat" />
              <Mapping SourceColumn="isAdmin" DataSetColumn="isAdmin" />
              <Mapping SourceColumn="ControlInMain" DataSetColumn="ControlInMain" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblQuyen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="LayQuyen" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="LayQuyen" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="LayQuyen">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ControlInMain, bFull, bIn, bNhap, bSua, bThem, bTruyCap, bXoa, bXuat, cItemKey, cItemTitle, cMoTa, cTenQuyen, cUserName, iItemID, iParentID, iQuyenID, isAdmin FROM tblQuyen WHERE (cUserName = @username) AND (cItemKey = @FormKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="cUserName" DataSourceName="CrewManagment.dbo.tblQuyen" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="FormKey" ColumnName="cItemKey" DataSourceName="CrewManagment.dbo.tblQuyen" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@FormKey" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsPermission" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsPermission" msprop:Generator_UserDSName="dsPermission">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblQuyen" msprop:Generator_TableClassName="tblQuyenDataTable" msprop:Generator_TableVarName="tabletblQuyen" msprop:Generator_TablePropName="tblQuyen" msprop:Generator_RowDeletingName="tblQuyenRowDeleting" msprop:Generator_UserTableName="tblQuyen" msprop:Generator_RowChangingName="tblQuyenRowChanging" msprop:Generator_RowEvHandlerName="tblQuyenRowChangeEventHandler" msprop:Generator_RowDeletedName="tblQuyenRowDeleted" msprop:Generator_RowEvArgName="tblQuyenRowChangeEvent" msprop:Generator_RowChangedName="tblQuyenRowChanged" msprop:Generator_RowClassName="tblQuyenRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="iQuyenID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columniQuyenID" msprop:Generator_ColumnPropNameInRow="iQuyenID" msprop:Generator_ColumnPropNameInTable="iQuyenIDColumn" msprop:Generator_UserColumnName="iQuyenID" type="xs:int" />
              <xs:element name="cUserName" msprop:Generator_ColumnVarNameInTable="columncUserName" msprop:Generator_ColumnPropNameInRow="cUserName" msprop:Generator_ColumnPropNameInTable="cUserNameColumn" msprop:Generator_UserColumnName="cUserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iItemID" msprop:Generator_ColumnVarNameInTable="columniItemID" msprop:Generator_ColumnPropNameInRow="iItemID" msprop:Generator_ColumnPropNameInTable="iItemIDColumn" msprop:Generator_UserColumnName="iItemID" type="xs:int" />
              <xs:element name="cItemTitle" msprop:Generator_ColumnVarNameInTable="columncItemTitle" msprop:Generator_ColumnPropNameInRow="cItemTitle" msprop:Generator_ColumnPropNameInTable="cItemTitleColumn" msprop:Generator_UserColumnName="cItemTitle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cItemKey" msprop:Generator_ColumnVarNameInTable="columncItemKey" msprop:Generator_ColumnPropNameInRow="cItemKey" msprop:Generator_ColumnPropNameInTable="cItemKeyColumn" msprop:Generator_UserColumnName="cItemKey" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iParentID" msprop:Generator_ColumnVarNameInTable="columniParentID" msprop:Generator_ColumnPropNameInRow="iParentID" msprop:Generator_ColumnPropNameInTable="iParentIDColumn" msprop:Generator_UserColumnName="iParentID" type="xs:int" minOccurs="0" />
              <xs:element name="cTenQuyen" msprop:Generator_ColumnVarNameInTable="columncTenQuyen" msprop:Generator_ColumnPropNameInRow="cTenQuyen" msprop:Generator_ColumnPropNameInTable="cTenQuyenColumn" msprop:Generator_UserColumnName="cTenQuyen" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMoTa" msprop:Generator_ColumnVarNameInTable="columncMoTa" msprop:Generator_ColumnPropNameInRow="cMoTa" msprop:Generator_ColumnPropNameInTable="cMoTaColumn" msprop:Generator_UserColumnName="cMoTa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bFull" msprop:Generator_ColumnVarNameInTable="columnbFull" msprop:Generator_ColumnPropNameInRow="bFull" msprop:Generator_ColumnPropNameInTable="bFullColumn" msprop:Generator_UserColumnName="bFull" type="xs:boolean" minOccurs="0" />
              <xs:element name="bTruyCap" msprop:Generator_ColumnVarNameInTable="columnbTruyCap" msprop:Generator_ColumnPropNameInRow="bTruyCap" msprop:Generator_ColumnPropNameInTable="bTruyCapColumn" msprop:Generator_UserColumnName="bTruyCap" type="xs:boolean" minOccurs="0" />
              <xs:element name="bThem" msprop:Generator_ColumnVarNameInTable="columnbThem" msprop:Generator_ColumnPropNameInRow="bThem" msprop:Generator_ColumnPropNameInTable="bThemColumn" msprop:Generator_UserColumnName="bThem" type="xs:boolean" minOccurs="0" />
              <xs:element name="bSua" msprop:Generator_ColumnVarNameInTable="columnbSua" msprop:Generator_ColumnPropNameInRow="bSua" msprop:Generator_ColumnPropNameInTable="bSuaColumn" msprop:Generator_UserColumnName="bSua" type="xs:boolean" minOccurs="0" />
              <xs:element name="bXoa" msprop:Generator_ColumnVarNameInTable="columnbXoa" msprop:Generator_ColumnPropNameInRow="bXoa" msprop:Generator_ColumnPropNameInTable="bXoaColumn" msprop:Generator_UserColumnName="bXoa" type="xs:boolean" minOccurs="0" />
              <xs:element name="bIn" msprop:Generator_ColumnVarNameInTable="columnbIn" msprop:Generator_ColumnPropNameInRow="bIn" msprop:Generator_ColumnPropNameInTable="bInColumn" msprop:Generator_UserColumnName="bIn" type="xs:boolean" minOccurs="0" />
              <xs:element name="bNhap" msprop:Generator_ColumnVarNameInTable="columnbNhap" msprop:Generator_ColumnPropNameInRow="bNhap" msprop:Generator_ColumnPropNameInTable="bNhapColumn" msprop:Generator_UserColumnName="bNhap" type="xs:boolean" minOccurs="0" />
              <xs:element name="bXuat" msprop:Generator_ColumnVarNameInTable="columnbXuat" msprop:Generator_ColumnPropNameInRow="bXuat" msprop:Generator_ColumnPropNameInTable="bXuatColumn" msprop:Generator_UserColumnName="bXuat" type="xs:boolean" minOccurs="0" />
              <xs:element name="isAdmin" msprop:Generator_ColumnVarNameInTable="columnisAdmin" msprop:Generator_ColumnPropNameInRow="isAdmin" msprop:Generator_ColumnPropNameInTable="isAdminColumn" msprop:Generator_UserColumnName="isAdmin" type="xs:boolean" minOccurs="0" />
              <xs:element name="ControlInMain" msprop:Generator_ColumnVarNameInTable="columnControlInMain" msprop:Generator_ColumnPropNameInRow="ControlInMain" msprop:Generator_ColumnPropNameInTable="ControlInMainColumn" msprop:Generator_UserColumnName="ControlInMain" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblQuyen" />
      <xs:field xpath="mstns:cUserName" />
      <xs:field xpath="mstns:iItemID" />
    </xs:unique>
  </xs:element>
</xs:schema>